Use the Index Name edit box to set the index name.
To include field(s) in the index, just simply click the Field(s) Name
to open the editor for editing.
Select the field(s) from the list. To remove the fields from the index, uncheck them in the same way. You can also use the arrow buttons to change the index field(s) order. The Key(s) Length edit box(s) is used to set index KEY LENGTH (1 - 255).
Note: Some of data types do not allow indexing by several fields. For example: BLOB
The Index Type dropdown list defines the type of the table index.
Normal
NORMAL indexes are the most basic indexes, and have no restraints such as uniqueness.Unique
UNIQUE indexes are the same as NORMAL indexes with one difference - all values of the indexed column(s) must only occur once.Full Text
FULL TEXT indexes are used by MySQL in full-text searches.